Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
Subordinate (FK)(PK) | A unique identifier for a specific Position. This may or may not be controlled by a centralized HR function. | ID_PST_SUB | Identity | integer | Position(CO_PST) |
Supervisor (FK)(PK) | A unique identifier for a specific Position. This may or may not be controlled by a centralized HR function. | ID_PST_SPVR | Identity | integer | Position(CO_PST) |
EffectiveDate | The valid start date for a position's reporting structure | DC_EF | EffectiveDate | date | |
ExpirationDate | The date that a position's reporting structure is no longer valid. | DC_EX | ExpirationDate | date | |